Club 30's "Kill the Boredom Demon" Jive Pad 124th Edition

last SG · 2009-08-06T15:28:02+00:00

in the other news, there's a dead pagolin lying along busy holland road ...... wonder how it got there .... it's pulpy road kill now ... what the?how did it...

SBS2601D SG

omg nikar7 hasn't got banned!

Even after elinda and trashbag?

elindra SG

I also dunno about Excel IF function.

Maybe the ppl in the IT support forum can help.

I only use for sum and doing stuff like calculating Gross Profit, Gross Margin etc

SBS2601D SG

My appeal for another module kena thrown out because I have to "wait till the entire bidding period" is over.

Which means I'll miss one week of that module.

SevenEleven SG

who is good in Excel IF function ??

Say i got the following cells

Salary, Yr, Result

Salary = $1000
Year = 26
Result = (I need to do a formula which states, IF year >25, take 25*salary, If year<=25, take year*salary)

But i can't get excel to calculate out for me. It just shows me "A1*25" as the answer instead of the figure

Help!

let A1 = Year

let A2 = salary

=if(A1<25,A1*A2,25*A2)

i think is correct

elindra SG

let A1 = Year

let A2 = salary

=if(A1<25,A1*A2,25*A2)

i think is correct

7-11 more Excel savvy than all of us

*hides face in shame*

starExcaliblur SG

who is good in Excel IF function ??

Say i got the following cells

Salary, Yr, Result

Salary = $1000
Year = 26
Result = (I need to do a formula which states, IF year >25, take 25*salary, If year<=25, take year*salary)

But i can't get excel to calculate out for me. It just shows me "A1*25" as the answer instead of the figure

Help!

if syntax: =IF(test condition, value if true, value if false)

The formula should be as below:
=IF(year>25, 25*salary, year*salary)

eg. cell A1=year, cell B1=salary
Placing the formula at cell C1 would be: =IF(A1>25,25*B1,A1*B1)

SBS2601D SG

7-11 more Excel savvy than all of us

*hides face in shame*

I've hardly touched excel....so how am I to know what's IF function?

And the sad thing is, I found that I had more patience sieving through some of the nikar BS, than the debate going on at the "teacher threatens to cut ear off" thread.

tare SG

*sipping vietnamese coffee*

i gonna fall asleep le >.<

SevenEleven SG

*sipping vietnamese coffee*

i gonna fall asleep le >.<

life is good huh?

SevenEleven SG

7-11 more Excel savvy than all of us

*hides face in shame*

look like i haven't aged

the Bear SG

bloody hell.. 7-11 today like damned thick skinned liddat

elindra SG

look like i haven't aged

Never use that function before ma

So only know how to use it for simple things like addition, subtraction, gross profit, margin that kind of things. LOL

SevenEleven SG

bloody hell.. 7-11 today like damned thick skinned liddat

i'm a keyboard warrior

SevenEleven SG

Never use that function before ma

So only know how to use it for simple things like addition, subtraction, gross profit, margin that kind of things. LOL

i was a programmer before a contractor

不如就死 SG

managed to get it right ...

okay ..

it should be

IF year <=25, yrs*salary, 25*salary

thank you very much ...

too long no use IF function, cannot remember ..

elindra SG

i was a programmer before a contractor

Big job change

LOL ok that is something I didn't know. Haha

kopiosatu SG

time to take a break from chrono trigger

SevenEleven SG

there's a bird family building a nest on the tree outside my window. I don't mind sharing the environment with them. it's just that they shit on the wind ledge

elindra SG

time to take a break from chrono trigger

Fun hor

The other good one is Secret of Mana

the Bear SG

there's a bird family building a nest on the tree outside my window. I don't mind sharing the environment with them. it's just that they shit on the wind ledge

go take pictures leh..

last time, when i was posted to woodlands, on the first day i noticed a weaver bird with the chick in the nest.. it was right outside the rest room...

when i went there with my camera the next day to take pictures, i saw the chick crawl out of the next and fly away.. and that was it.. opportunity lost forever..

« Previous Page Next Page »